| |
|
|
|
Use MyProfiler to :
Monitor the performance of an instance MySql .
Troubleshoot problems in MySql by capturing events on a production system and replaying them on a test system. This is useful for testing or debugging purposes and allows users to continue using the production system without interference.
Audit and review activity that occurred on an instance of SQL Server. This allows a security administrator to review any of the auditing events, including the success and failure of a login attempt and the success and failure of permissions in accessing statements and objects.
Get a full list of the statements executed on your server and the time of execution. This helps shared hosts to charge the users by usage .
Helps you detect bottlenecks and determine high usage days and hours on your server .
Use the Index tuning wizard to determine the best organization of indexes on your databases .The index tuning wizard allows gives u a recommendation on creating the indexes in your tables .
Tracing :
In the tracing window you will see the events that occur on your server .MyProfiler captures the following events : SQL Queries -Login attempts-Shutdown-Connection terminating2)Logging :
MyProfiler allows you to log the events that occur on your server to a text file or a MySql table. You can set limitation on the size of the text file or the number of rows of the table to avoid extreme growth .When you choose the logging to a mysql table you can use this workload as an input to the index tuning wizard to analyze the best index structure on your database .
3)Index tuning wizard :
The Index Tuning Wizard allows you to select and create an optimal set of indexes and statistics for a MySql Server database without requiring an expert understanding of the structure of the database, the workload, or the internals of MySQL Server.The wizard will recommend the best mix of indexes for a database. |
| « read more about MyProfiler 1.0 |
|
|
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| » CCXI XML Data Island Library 2004.0
|
| Take the Strain off Your Server. Use the CCXI XML Data Island Library and ASP table control to allow users to interact with an entire dataset--without having to constantly contact the server for processing. When you need to display a moderate amount of ... |
|
| Higher Math | 822KB | Win 98/ME/2000/XP | $50 | Downloads: 1290 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SQL Developer 1.0
|
| Database programmer`s workplace used to create and execute SQL queries and scripts, debug script execution, view results and manage databases. SQL Developer is compatible to any kind of relational databases that support SQL, including, but not limited t ... |
|
| Guru Developers | 465KB | Win 95/98/ME/NT/2000/XP | $50 | Downloads: 1390 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Multiple Database Query Analyzer 2.1
|
| Multiple Database Query Analyzer 2.1 supports qurries with diffrent types of databases. It supports Sql, Access, Oracle, MySql. It lets you have diffrent profiles to store data, also has options to hold querrys and export data. ... |
|
| VsiSoftware.com | 9585KB | Win 95/98/ME/NT/2000/XP | $29.95 | Downloads: 1244 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » PostgresDAC 1.8.1
|
| PostgresDAC is PostgreSQL BDE replacement for Delphi/C++Builder. It allows to create Delphi/C++Builder applications with the direct access to PostgreSQL DB without BDE and ODBC. This components set was developed for easy migration of existing projects ... |
|
| microOLAP Technologies LTD | 1784KB | Win 95/98/ME/NT/2000 | $59.95 | Downloads: 1348 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SQL Server Comparison Tool 1.2
|
| SQL Server Comparison Tool is a Windows program for analyzing, comparing and documenting SQL Server databases. It`s an ideal tool for Database Administrators (DBA) and Developers. With SQL Server Comparison Tool you can take full control of your databas ... |
|
| AlfaAlfa Software | 3511KB | Win 95/98/ME/NT/2000/XP | $99 | Downloads: 1299 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Force-Field 4.2.0
|
| The component accomplishes main tasks in building a security scheme for your application. It performs authentification and authorization of users: controls access of certain users to some system objects. The core advantages · Reducing of development cost ... |
|
| BYTE-force | 356KB | Win 98/ME/NT/2000/XP | $199 | Downloads: 1392 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Data Quik 3.0
|
| Data Quik - The Database File Copier allows you to copy selected fields and records between some of the major Database Files. In general terms, Data Quik-The Database Copy Utility is an add on Database utility that performs the following functions: 1. Co ... |
|
| Accessory Software | 9789KB | Win 95/98/ME/NT/2000/XP | $25.00 | Downloads: 1262 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Projectname Manager 1.4
|
| AutoCAD uses `projectnames` to better manage drawings. With each projectname, a different search path can be set for finding XREF drawings. For a large office, managing these projectnames and their associated paths can be difficult. Projectname Manage ... |
|
| CGinther Software | 2367KB | Win 95/98/NT/2000 | $15 | Downloads: 1239 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Menu Update 2002
|
| For large offices that have their own custom AutoCAD menu, Menu Update helps simplify the distribution of menu changes to all users. If everyone uses the menu files directly from a shared location, you cannot change the master menu file, because the fil ... |
|
| CGinther Software | 2755KB | Win 95/98/NT/2000 | $15 | Downloads: 1258 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Access-to-MSSQL 1.3
|
| Access-to-MSSQL is a program to move MS Access databases to MSSQL server. Key features: (1) all MS Access data types and attributes are supported (2) converts indexes with all necessary attributes (3) command line support (4) converts password protecte ... |
|
| Intelligent Converters | 515.8KB | Win 95/98/ME/NT/2000 | $39.85 | Downloads: 1311 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| » Mysql Data Manager 1.72
|
| The program is intended to remotely manage mysql database engines over the Internet or Intranet using web browser based interface. Mysql Data Manager is a multifunctional and platform independent web based mysql front end with a powerful user interface fo ... |
|
| cgiscriptshop.com | 86.2KB | Not Applicable | $37.00 | Downloads: 1208 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Excel-to-MSSQL 1.0
|
| Excel-to-MSSQL is a program to convert MS Excel spreadsheets into MS SQL databases. Each worksheet becomes a table, each row becomes a record and each cell becomes a field. Key features: (1) all versions of MS Excel are supported (2) converts individua ... |
|
| Intelligent Converters | 774.4KB | Win 95/98/ME/NT/2000 | $29.85 | Downloads: 1214 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » MSSQL-to-Excel 1.0
|
| MSSQL-to-Excel is a program to convert MS SQL databases into MS Excel spreadsheet. Key features: (1) all MS SQL data types are supported (2) fast conversion engine (20MB MS SQL database - in 1 minute on average P-III system) (3) converts individual tabl ... |
|
| Intelligent Converters | 733.4KB | Win 95/98/ME/NT/2000 | $29.85 | Downloads: 1255 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » MyDBA Oracle Databases Observer 2.0.26
|
| MyDBA is a powerful graphical tool to retrieve essential information from any Oracle database. Quickly detect potential problems in your databases. Storages, user sessions, I/O, instance parameters and much more. In addition to all functionalities of th ... |
|
| Serguei FRAMPOL | 13MB | Win 95/98/ME/NT/2000/XP | $59 | Downloads: 1331 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » 4TOPS Word Link for MS Access 2000 4.1
|
| 4TOPS Word Link is an add-in for Microsoft Access, which adds data from Microsoft Access in Word documents. You can compose simple and more complex documents, such as standard letters, invoices and reports. Open the Microsoft Access form which contains th ... |
|
| 4TOPS | 4587KB | Win 95/98/ME/NT/2000 | $179 | Downloads: 1547 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » 4TOPS Word Link for MS Access 97 4.1
|
| 4TOPS Word Link is an add-in for Microsoft Access, which adds data from Microsoft Access in Word documents. You can compose simple and more complex documents, such as standard letters, invoices and reports. Open the Microsoft Access form which contains th ... |
|
| 4TOPS | 4693KB | Win 95/98/ME/NT/2000 | $179 | Downloads: 1494 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » PDB Tools 1.1
|
| UNIQUE TOOL FOR DEVELOPERS! Manage all PDB data in a Palm from Windows! ... |
|
| TISA | 2800KB | Palm OS | $27.99 | Downloads: 1413 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » 4TOPS Document Management in MS Access 2000 2.2
|
| 4TOPS Document Management is an addin to create and manage documents using your MS Access Database. Create documents with content from your database. Instantly find and share documents. View all information on the document in an Access form. All file mana ... |
|
| 4TOPS | 1591KB | Win 95/98/ME/NT/2000/XP | $399 | Downloads: 1576 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » 4TOPS Document Management in MS Access 97 2.2
|
| 4TOPS Document Management is an addin to create and manage documents using your MS Access Database. Create documents with content from your database. Instantly find and share documents. View all information on the document in an Access form. All file mana ... |
|
| 4TOPS | 1281KB | Win 95/98/ME/NT/2000/XP | $399 | Downloads: 1486 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Palm Debugger 1.0
|
| UNIQUE TOOL FOR DEVELOPERS! Manage all PDB data and Resources on-line from Palm device. Ideal for debugging, analyze and fix problems... Get information about: - Device resources: view statistics, softtware versions, etc. - DataBases: view, Sort and Pri ... |
|
| TISA | 3200KB | Palm OS | $34.95 | Downloads: 1262 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| |
